USE [dbdata]
GO
CREATE ROLE [WebAdminRole] AUTHORIZATION [dbo]
EXEC dbo.sp_addrolemember @rolename=N'WebAdminRole', @membername=N'WebAdmin'
EXEC dbo.sp_addrolemember @rolename=N'Browser', @membername=N'WebAdmin'
GO
USE [management]
GO
CREATE ROLE [WebAdminRole] AUTHORIZATION [dbo]
EXEC dbo.sp_addrolemember @rolename=N'WebAdminRole', @membername=N'WebAdmin'
EXEC dbo.sp_addrolemember @rolename=N'Browser', @membername=N'WebAdmin'
GRANT INSERT ON [dbo].[users] TO [WebAdminRole] AS [dbo]
GRANT UPDATE ON [dbo].[users] TO [WebAdminRole] AS [dbo]
GO

USE [sms_p]
CREATE ROLE [WebAdminRole] AUTHORIZATION [dbo]
EXEC dbo.sp_addrolemember @rolename=N'WebAdminRole', @membername=N'WebAdmin'
EXEC dbo.sp_addrolemember @rolename=N'Browser', @membername=N'WebAdmin'
EXEC dbo.sp_addrolemember @rolename=N'Executer', @membername=N'WebAdmin'

USE [meps]
CREATE ROLE [WebAdminRole] AUTHORIZATION [dbo]
EXEC dbo.sp_addrolemember @rolename=N'WebAdminRole', @membername=N'WebAdmin'
EXEC dbo.sp_addrolemember @rolename=N'Browser', @membername=N'WebAdmin'



/*
use dbdata
GRANT SELECT ON [dbo].[phones] TO [Browser] AS [dbo]
GO
*/



